package com.thj.dao.impl;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.junit.Test;

import com.dao.BaseDao;
import com.thj.dao.StatusmsgDao;
import com.thj.po.StatusmsgPo;

public class StatusmsgDaoImpl implements StatusmsgDao {

	@Override
	public StatusmsgPo findStaById(Integer StatusmsgId) {
		BaseDao baseDao = new BaseDao();
		StatusmsgPo statusmsgPo = null;
		String sql = "select * from statusmsg where customer_id=?";
		
		//CUSTOMER_ID
		//Map<String, String> columnsMap = new HashMap<String, String>();
		//columnsMap.put("role_id", "id");
		List<StatusmsgPo> list = baseDao.executeQuery(sql, null, StatusmsgPo.class, StatusmsgId);
		return (list != null && list.size() > 0) ? list.get(0) : null;
	}
	
	@Test
	public void test01(){
		System.out.println(this.findStaById(1001));
	}

}
